Skip Headers

Oracle® Database Backup and Recovery Reference 10g Release 2 (10.2) Part Number B14194-03 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# RC_BACKUP_SET_DETAILS

`RC_BACKUP_SET_DETAILS` provides details about currently available backup sets, including backup sets created by the use of the BACKUP BACKUPSET command.

This view is primarily intended to be used internally by Enterprise Manager.

Column | Datatype | Description
--- | --- | ---
`SESSION_KEY` | `NUMBER` | Session identifier. Use in joins with RC_RMAN_OUTPUT.
`SESSION_RECID` | `NUMBER` | Together with SESSION_STAMP, uniquely identifies output for this backup job from RC_RMAN_OUTPUT.
`SESSION_STAMP` | `NUMBER` | Together with SESSION_RECID, uniquely identifies output for this backup job from RC_RMAN_OUTPUT.
`DB_KEY` | `NUMBER` | The primary key for this database in the recovery catalog. Use this column to form a join with almost any other catalog view.
`DB_NAME` | `VARCHAR2(8)` | The `DB_NAME` of the database incarnation to which this record belongs.
`BS_KEY` | `NUMBER` | The primary key of the backup set to which this record belongs in the recovery catalog.
`RECID` | `NUMBER` | The backup set RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file.
`STAMP` | `NUMBER` | The backup set RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file.
`SET_STAMP` | `NUMBER` | The SET_STAMP value from V$BACKUP_SET. SET_STAMP and SET_COUNT form a concatenated key that uniquely identifies this record in the target database control file.
`SET_COUNT` | `NUMBER` | The SET_COUNT value from V$BACKUP_SET. SET_STAMP and SET_COUNT form a concatenated key that uniquely identifies this record in the target database control file.
`BACKUP_TYPE` | `VARCHAR2(1)` | The type of the backup: D (full backup or level 0 incremental), I (incremental level 1), L (archived redo log).
`CONTROLFILE_INCLUDED` | `VARCHAR2(7)` | Possible values are NONE (backup set does not include a backup control file), BACKUP (backup set includes a normal backup control file), and STANDBY (backup set includes a standby control file).
`INCREMENTAL_LEVEL` | `NUMBER` | The level of the incremental backup: NULL, 0, or 1.
`PIECES` | `NUMBER` | The number of backup pieces in the backup set.
`START_TIME` | `DATE` | The time when the backup began.
`COMPLETION_TIME` | `DATE` | The time when the backup completed
`ELAPSED_SECONDS` | `NUMBER` | The duration of the backup in seconds.
`BLOCK_SIZE` | `NUMBER` | The block size used when creating the backup pieces in the backup set.
`KEEP` | `VARCHAR2(3)` | Indicates whether this backup set has a retention policy different from the value for CONFIGURE RETENTION POLICY. Possible values are YES and NO.
`KEEP_UNTIL` | `DATE` | If the KEEP UNTIL TIME clause of the BACKUP command was specified, then this column shows the date after which this backup becomes obsolete. If the column is NULL and KEEP OPTIONS is not NULL, the backup never becomes obsolete.
`KEEP_OPTIONS` | `VARCHAR2(10)` | The KEEP options specified for this backup set. Options can be LOGS (RMAN keeps the logs needed to recover this backup), NOLOGS (RMAN does not keep the logs needed to recover this backup), or NULL (the backup has no KEEP options and is subject to the default retention policy).
`DEVICE_TYPE` | `VARCHAR2(255)` | Device type on which the backup is stored. If the backup set is stored on more than one type of device (for example, if a backup set created on disk and still present on disk has also been backed up to tape using BACKUP BACKUPSET), this column contains "*". For backups on disk, `DISK`. Otherwise...
`COMPRESSED` | `VARCHAR2(3)` | YES if RMAN's binary compression was used in creating the backup set. NO, otherwise.
`NUM_COPIES` | `NUMBER` | Number of identical copies of this backup set created during the backup, for example if duplexing was used.
`OUTPUT_BYTES` | `NUMBER` | Sum of sizes of all output pieces generated by this job.
`ORIGINAL_INPUT_BYTES` | `NUMBER` | Sum of sizes of all input files backed up for this job.
`COMPRESSION_RATIO` | `NUMBER` | Compression ratio for this backup. Otherwise...
`STATUS` | `CHAR(1)` | The status of the backup set: always A (all backup pieces available), because this view only reflects available backup sets.
`ORIGINAL_INPRATE_BYTES` | `NUMBER` | Number of bytes read each second when the backup set was initially created.
`OUTPUT_RATE_BYTES` | `NUMBER` | Number of bytes written each second when the backup set was initially created.
`ORIGINAL_INPUT_BYTES_DISPLAY` | `VARCHAR2(4000)` | Same value as `ORIGINAL_INPUT_BYTES`, but converted to a user-displayable format, for example nM, nG, nT, nP.
`OUTPUT_BYTES_DISPLAY` | `VARCHAR2(4000)` | Same value as `OUTPUT_BYTES`, but converted to a user-displayable format, for example nM, nG, nT, nP.
`ORIGINAL_INPRATE_BYTES_DISPLAY` | `VARCHAR2(4000)` | Same value as `ORIGINAL_INPRATE_BYTES`, but converted to a user-displayable format, for example nM, nG, nT, nP.
`OUTPUT_RATE_BYTES_DISPLAY` | `VARCHAR2(4000)` | Same value as `OUTPUT_RATE_BYTES`, but converted to a user-displayable format, for example nM, nG, nT, nP.
`TIME_TAKEN_DISPLAY` | `VARCHAR2(4000)` | Same value as `ELAPSED_SECONDS`, but converted to a user-displayable format in hours, minutes and seconds.